|
|
|
|
- Deletion and modification rule
<Source>.ListLink (Function) In french: <Source>.ListeLiaison
Not available with this kind of connection
Returns the list of a data file links (Merise type) present.: - in the current analysis,
New in version 2024in ongoing analyses (case of projects with multiple analyses). - in a specific analysis.
ListeLiaison est une chaîne
ListeLiaison = Client.ListeLiaison(HLstDétail)
COMBO_MaCombo.Ajoute(ListeLiaison)
Syntax
Listing the links of a data file in an analysis Hide the details
<Result> = <Source>.ListLink([<Path of the WDD file> [, <Password of the WDD file>]] [, <Options>])
<Result>: Character string List of links. New in version 2024Projects with multiple analyses: If several analyses are in progress, all links of all analyses in progress are listed (without duplicates). The different link descriptions are separated by CR characters (Carriage Return). The result is more or less detailed depending on the constant used: | | hLstDetail is not specified | <Name link1> + TAB + <Name file1.1> + TAB + <Name item1.1> + TAB + <Cardinality 1.1> + TAB + <Name file1.2> + TAB + <Name item1.2> + TAB + <Cardinality 1.2> + CR +... | hLstDetail is specified | <Name link1> + TAB + <Name file1.1> + TAB + <Name item1.1> + TAB + <Cardinality 1.1> + TAB + <Name file1.2> + TAB + <Name item1.2> + TAB + <Cardinality 1.2> + TAB + <Modification rule> + TAB + <Deletion rule> + CR +... |
Where:- <Name link X>: link name.
- <Name file x.1>:: Name of the data file related to the primary key.
- <Name item x.1>: Name of the item related to the primary key or name of the specified data file.
- <Cardinality x.1>: Cardinality of the link related to the primary key in the following format: "<Min cardinality>, <Max cardinality>" ("0, N" or "1, N" for example).
- <Name file x.2>: Name of the data file related to the foreign key.
- <Name item x.2>: Name of the item related to the foreign key.
- <Cardinality x.2>: Cardinality of the link related to the foreign key in the following format: "<Min cardinality>, <Max cardinality>" ("0, N" or "1, N" for example).
- <Modification rule>: Rule to apply if the primary key is modified.
- <Deletion rule>: Rule to apply if the primary key is deleted.
<Source>: Type corresponding to the specified source Name of the data file whose links must be listed. The links originating from this file or ending at this file are listed. <Path of the WDD file>: Optional character string Full path of the analysis file (.WDD file). If this parameter is not specified or is equal to an empty string (""), links are searched for: - in the current analysis.
New in version 2024in all current analyses (case of projects with multiple analyses).
<Password of the WDD file>: Optional character string Password defined for the analysis. If no password is defined, this parameter must be equal to an empty string (""). <Options>: Optional integer constant Type of list to perform: | | hLstDetail | Lists the detailed information about the links. | hLstNormal (default value) | Lists the links. |
Listing the links of a data file accessible via Native Connector or OLE DB, or via an HFSQL Client/Server connection Hide the details
<Result> = <Source>.ListLink([<Connection>] [, <Options>])
<Result>: Character string List of links. The different link descriptions are separated by CR characters (Carriage Return). The result is more or less detailed depending on the constant used: | | hLstDetail is not specified | <Name link1> + TAB + <Name file1.1> + TAB + <Name item1.1> + TAB + <Cardinality 1.1> + TAB + <Name file1.2> + TAB + <Name item1.2> + TAB + <Cardinality 1.2> + CR +... | hLstDetail is specified | <Name link1> + TAB + <Name file1.1> + TAB + <Name item1.1> + TAB + <Cardinality 1.1> + TAB + <Name file1.2> + TAB + <Name item1.2> + TAB + <Cardinality 1.2> + TAB + <Modification rule> + TAB + <Deletion rule> + CR +... |
Where:- <Name link X>: link name.
- <Name file x.1>:: Name of the data file related to the primary key.
- <Name item x.1>: Name of the item related to the primary key or name of the specified data file.
- <Cardinality x.1>: Cardinality of the link related to the primary key in the following format: "<Min cardinality>, <Max cardinality>" ("0, N" or "1, N" for example).
- <Name file x.2>: Name of the data file related to the foreign key.
- <Name item x.2>: Name of the item related to the foreign key.
- <Cardinality x.2>: Cardinality of the link related to the foreign key in the following format: "<Min cardinality>, <Max cardinality>" ("0, N" or "1, N" for example).
- <Modification rule>: Rule to apply if the primary key is modified (see Remarks).
- <Deletion rule>: Rule to apply if the primary key is deleted (see Remarks).
<Source>: Type corresponding to the specified source Name of the data file whose links must be listed. The links originating from this file or ending at this file are listed. <Connection>: Character string or Connection variable Connection to use. This connection corresponds to: <Options>: Optional integer constant Type of list to perform: | | hLstDetail | Lists the detailed information about the links. | hLstNormal (default value) | Lists the links. |
Remarks Deletion and modification rule The modification and deletion rules returned by <Source>.ListLink can correspond to the following constants: | | hIntegrityCascade | Manage the cascading modification and deletion. | hIntegrityDefaultValue | During the deletion, a default value is assigned to the linked records. | hIntegrityForbidden | Strict respect of integrity. | hIntegrityNone | No integrity constraint. |
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|